Release 10.1A: OpenEdge Data Management:
SQL Reference

TO_TIME

Converts the given time literal to a time value.

Syntax

TO_TIME ( time_literal )

Example

The following example shows how to use the TO_DATE and the TO_TIME functions:

SELECT * FROM orders WHERE order_date < TO_DATE ('05/15/2003') AND order_time < TO_TIME ('12:00:00') ;

Notes

The result is of type TIME.
Supply the time literal in any valid format.

Compatibility

Progress extension